package com.lucker.ds.model;

import java.math.BigDecimal;
import java.util.Date;

/**
 * cai_piao_opencode_backup
 * @author 
 */
public class CaiPiaoOpencodeBackup extends BaseValueObject {
    private Long id;

    /**
     * 彩票ID
     */
    private String caiId;

    /**
     * 冗余字段 彩票名称
     */
    private String caiName;

    /**
     * 彩票类型ID
     */
    private String caiTypeId;

    /**
     * 期号
     */
    private String issueno;

    /**
     * 中奖号码
     */
    private String number1;

    private String number2;

    private String number3;

    private String number4;

    private String number5;

    private String number6;

    private String number7;

    private String number8;

    private String number9;

    /**
     * 参考号
     */
    private String refernumber;

    /**
     * 开奖日期
     */
    private Date opendate;

    /**
     * 兑奖截止日期
     */
    private Date deadline;

    /**
     * 销售额
     */
    private BigDecimal saleamount;

    /**
     * 奖项
     */
    private String prizename;

    /**
     * 中奖人数
     */
    private Integer num;

    /**
     * 单注金额
     */
    private BigDecimal singlebonus;

    /**
     * 中奖情况
     */
    private String prize;

    /**
     * 奖池奖金
     */
    private BigDecimal totalmoney;

    private String extend1;

    private String extend2;

    private String extend3;

    private String customQuerySqlText = null;

    private String orderStr = null;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getCaiId() {
        return caiId;
    }

    public void setCaiId(String caiId) {
        this.caiId = caiId;
    }

    public String getCaiName() {
        return caiName;
    }

    public void setCaiName(String caiName) {
        this.caiName = caiName;
    }

    public String getCaiTypeId() {
        return caiTypeId;
    }

    public void setCaiTypeId(String caiTypeId) {
        this.caiTypeId = caiTypeId;
    }

    public String getIssueno() {
        return issueno;
    }

    public void setIssueno(String issueno) {
        this.issueno = issueno;
    }

    public String getNumber1() {
        return number1;
    }

    public void setNumber1(String number1) {
        this.number1 = number1;
    }

    public String getNumber2() {
        return number2;
    }

    public void setNumber2(String number2) {
        this.number2 = number2;
    }

    public String getNumber3() {
        return number3;
    }

    public void setNumber3(String number3) {
        this.number3 = number3;
    }

    public String getNumber4() {
        return number4;
    }

    public void setNumber4(String number4) {
        this.number4 = number4;
    }

    public String getNumber5() {
        return number5;
    }

    public void setNumber5(String number5) {
        this.number5 = number5;
    }

    public String getNumber6() {
        return number6;
    }

    public void setNumber6(String number6) {
        this.number6 = number6;
    }

    public String getNumber7() {
        return number7;
    }

    public void setNumber7(String number7) {
        this.number7 = number7;
    }

    public String getNumber8() {
        return number8;
    }

    public void setNumber8(String number8) {
        this.number8 = number8;
    }

    public String getNumber9() {
        return number9;
    }

    public void setNumber9(String number9) {
        this.number9 = number9;
    }

    public String getRefernumber() {
        return refernumber;
    }

    public void setRefernumber(String refernumber) {
        this.refernumber = refernumber;
    }

    public Date getOpendate() {
        return opendate;
    }

    public void setOpendate(Date opendate) {
        this.opendate = opendate;
    }

    public Date getDeadline() {
        return deadline;
    }

    public void setDeadline(Date deadline) {
        this.deadline = deadline;
    }

    public BigDecimal getSaleamount() {
        return saleamount;
    }

    public void setSaleamount(BigDecimal saleamount) {
        this.saleamount = saleamount;
    }

    public String getPrizename() {
        return prizename;
    }

    public void setPrizename(String prizename) {
        this.prizename = prizename;
    }

    public Integer getNum() {
        return num;
    }

    public void setNum(Integer num) {
        this.num = num;
    }

    public BigDecimal getSinglebonus() {
        return singlebonus;
    }

    public void setSinglebonus(BigDecimal singlebonus) {
        this.singlebonus = singlebonus;
    }

    public String getPrize() {
        return prize;
    }

    public void setPrize(String prize) {
        this.prize = prize;
    }

    public BigDecimal getTotalmoney() {
        return totalmoney;
    }

    public void setTotalmoney(BigDecimal totalmoney) {
        this.totalmoney = totalmoney;
    }

    public String getExtend1() {
        return extend1;
    }

    public void setExtend1(String extend1) {
        this.extend1 = extend1;
    }

    public String getExtend2() {
        return extend2;
    }

    public void setExtend2(String extend2) {
        this.extend2 = extend2;
    }

    public String getExtend3() {
        return extend3;
    }

    public void setExtend3(String extend3) {
        this.extend3 = extend3;
    }

    public void setCustomQuerySqlText(String customQuerySqlText) {
        this.customQuerySqlText = customQuerySqlText;
    }

    public String getCustomQuerySqlText() {
        return customQuerySqlText;
    }

    public void orderById(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by id asc";
            }else{
                this.orderStr = this.orderStr + ",id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by id desc";
            }else{
                this.orderStr = this.orderStr + ",id desc";
            }
        }
    }

    public void orderByCaiId(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by cai_id asc";
            }else{
                this.orderStr = this.orderStr + ",cai_id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by cai_id desc";
            }else{
                this.orderStr = this.orderStr + ",cai_id desc";
            }
        }
    }

    public void orderByCaiName(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by cai_name asc";
            }else{
                this.orderStr = this.orderStr + ",cai_name asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by cai_name desc";
            }else{
                this.orderStr = this.orderStr + ",cai_name desc";
            }
        }
    }

    public void orderByCaiTypeId(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by cai_type_id asc";
            }else{
                this.orderStr = this.orderStr + ",cai_type_id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by cai_type_id desc";
            }else{
                this.orderStr = this.orderStr + ",cai_type_id desc";
            }
        }
    }

    public void orderByIssueno(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by issueno asc";
            }else{
                this.orderStr = this.orderStr + ",issueno asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by issueno desc";
            }else{
                this.orderStr = this.orderStr + ",issueno desc";
            }
        }
    }

    public void orderByNumber1(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by number1 asc";
            }else{
                this.orderStr = this.orderStr + ",number1 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by number1 desc";
            }else{
                this.orderStr = this.orderStr + ",number1 desc";
            }
        }
    }

    public void orderByNumber2(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by number2 asc";
            }else{
                this.orderStr = this.orderStr + ",number2 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by number2 desc";
            }else{
                this.orderStr = this.orderStr + ",number2 desc";
            }
        }
    }

    public void orderByNumber3(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by number3 asc";
            }else{
                this.orderStr = this.orderStr + ",number3 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by number3 desc";
            }else{
                this.orderStr = this.orderStr + ",number3 desc";
            }
        }
    }

    public void orderByNumber4(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by number4 asc";
            }else{
                this.orderStr = this.orderStr + ",number4 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by number4 desc";
            }else{
                this.orderStr = this.orderStr + ",number4 desc";
            }
        }
    }

    public void orderByNumber5(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by number5 asc";
            }else{
                this.orderStr = this.orderStr + ",number5 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by number5 desc";
            }else{
                this.orderStr = this.orderStr + ",number5 desc";
            }
        }
    }

    public void orderByNumber6(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by number6 asc";
            }else{
                this.orderStr = this.orderStr + ",number6 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by number6 desc";
            }else{
                this.orderStr = this.orderStr + ",number6 desc";
            }
        }
    }

    public void orderByNumber7(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by number7 asc";
            }else{
                this.orderStr = this.orderStr + ",number7 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by number7 desc";
            }else{
                this.orderStr = this.orderStr + ",number7 desc";
            }
        }
    }

    public void orderByNumber8(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by number8 asc";
            }else{
                this.orderStr = this.orderStr + ",number8 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by number8 desc";
            }else{
                this.orderStr = this.orderStr + ",number8 desc";
            }
        }
    }

    public void orderByNumber9(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by number9 asc";
            }else{
                this.orderStr = this.orderStr + ",number9 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by number9 desc";
            }else{
                this.orderStr = this.orderStr + ",number9 desc";
            }
        }
    }

    public void orderByRefernumber(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by refernumber asc";
            }else{
                this.orderStr = this.orderStr + ",refernumber asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by refernumber desc";
            }else{
                this.orderStr = this.orderStr + ",refernumber desc";
            }
        }
    }

    public void orderByOpendate(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by opendate asc";
            }else{
                this.orderStr = this.orderStr + ",opendate asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by opendate desc";
            }else{
                this.orderStr = this.orderStr + ",opendate desc";
            }
        }
    }

    public void orderByDeadline(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by deadline asc";
            }else{
                this.orderStr = this.orderStr + ",deadline asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by deadline desc";
            }else{
                this.orderStr = this.orderStr + ",deadline desc";
            }
        }
    }

    public void orderBySaleamount(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by saleamount asc";
            }else{
                this.orderStr = this.orderStr + ",saleamount asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by saleamount desc";
            }else{
                this.orderStr = this.orderStr + ",saleamount desc";
            }
        }
    }

    public void orderByPrizename(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by prizename asc";
            }else{
                this.orderStr = this.orderStr + ",prizename asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by prizename desc";
            }else{
                this.orderStr = this.orderStr + ",prizename desc";
            }
        }
    }

    public void orderByNum(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by num asc";
            }else{
                this.orderStr = this.orderStr + ",num asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by num desc";
            }else{
                this.orderStr = this.orderStr + ",num desc";
            }
        }
    }

    public void orderBySinglebonus(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by singlebonus asc";
            }else{
                this.orderStr = this.orderStr + ",singlebonus asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by singlebonus desc";
            }else{
                this.orderStr = this.orderStr + ",singlebonus desc";
            }
        }
    }

    public void orderByPrize(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by prize asc";
            }else{
                this.orderStr = this.orderStr + ",prize asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by prize desc";
            }else{
                this.orderStr = this.orderStr + ",prize desc";
            }
        }
    }

    public void orderByTotalmoney(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by totalmoney asc";
            }else{
                this.orderStr = this.orderStr + ",totalmoney asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by totalmoney desc";
            }else{
                this.orderStr = this.orderStr + ",totalmoney desc";
            }
        }
    }

    public void orderByExtend1(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by extend1 asc";
            }else{
                this.orderStr = this.orderStr + ",extend1 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by extend1 desc";
            }else{
                this.orderStr = this.orderStr + ",extend1 desc";
            }
        }
    }

    public void orderByExtend2(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by extend2 asc";
            }else{
                this.orderStr = this.orderStr + ",extend2 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by extend2 desc";
            }else{
                this.orderStr = this.orderStr + ",extend2 desc";
            }
        }
    }

    public void orderByExtend3(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by extend3 asc";
            }else{
                this.orderStr = this.orderStr + ",extend3 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by extend3 desc";
            }else{
                this.orderStr = this.orderStr + ",extend3 desc";
            }
        }
    }
}